How to: Open a group of related workbooks all at once (create a workspace).
Solution:
Open and arrange workbooks to be included in the workspace. Select 'Save Workspace' from the 'File' menu.
1) Open all workbooks to be included in the workspace.
2) (Optional) Arrange the workbook windows as they are to appear when the user opens them:
a) Select the 'Window' menu and select 'Arrange'.
b) Select one of the radio buttons.
3) Select the 'File' menu and select 'Save Workspace'.
4) Type a name for the workspace. (The default name is RESUME.XLW.)
CAUTION: Files contained in a workspace must not be moved from their location or Excel will be unable to locate them when the workspace is opened.
